﻿CREATE TABLE [dbo].[Config]
(
    [Id] INT NOT NULL IDENTITY, 
	[Name] NVARCHAR(50) NOT NULL , 
    [Value] NVARCHAR(MAX) NOT NULL, 
    [Enable] BIT NOT NULL DEFAULT 1
)

GO

CREATE INDEX [IX_Config_Name] ON [dbo].[Config] ([Name])

GO

EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'配置键名',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Config',
    @level2type = N'COLUMN',
    @level2name = N'Name'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'配置键值',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Config',
    @level2type = N'COLUMN',
    @level2name = N'Value'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'是否启用配置',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Config',
    @level2type = N'COLUMN',
    @level2name = N'Enable'